<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<jsp:root xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:ui="http://java.sun.com/jsf/facelets"
	xmlns:h="http://java.sun.com/jsf/html"
	xmlns:f="http://java.sun.com/jsf/core"
	xmlns:p="http://primefaces.org/ui"
	xmlns:t="http://myfaces.apache.org/tomahawk">

	<ui:composition template="/template/pPrincipal.xhtml">

		<ui:define name="head">
			<title>BBVAITrade</title>
		</ui:define>

		<ui:define name="titulopagina">
			<p:toolbar>
				<p:toolbarGroup align="left" style="height: 20px;">
					<h:outputText value="CONSULTA VISTA BANCO"
						styleClass="textoTituloPagina" />
				</p:toolbarGroup>
			</p:toolbar>
		</ui:define>

		<ui:define name="bodyarea">
			<f:event type="preRenderView" listener="#{rankingPaisesController.onPageLoad}"/>
			<p:messages id="growl" ></p:messages>
			<p:tabMenu activeIndex="0">
				<p:menuitem value="Raking Países" ajax="true"
					url="/pages/banco/rakingPaises.xhtml" icon="ui-icon-circle-check" />
				<p:menuitem value="Raking Bancos" ajax="true"
					url="/pages/banco/rakingBancos.xhtml" icon="ui-icon-circle-check" />
				<p:menuitem value="Raking Clientes" ajax="true"
					url="/pages/banco/rakingClientes.xhtml" icon="ui-icon-circle-check" />
				<p:menuitem value="Catalogo de Bancos" ajax="true"
					url="/pages/banco/catalogoBancos.xhtml" icon="ui-icon-circle-check" />
			</p:tabMenu>

			<h:panelGrid columns="1" cellpadding="0" cellspacing="0" id="pnlGripRakingPaises" style="width:100%">
				<h:panelGrid headerClass="cabeceraPanelSimple" cellspacing="0"
					cellpadding="5" styleClass="bordePanel"
					style="width:100%; margin-left: 0px; margin-top: 1px; margin-bottom:5px" columns="1">
	
					<f:facet name="header">
						<table cellpadding="0" cellspacing="0" width="100%" border="0" >
							<tr>
								<td>
									<h:outputText value="Filtro de Búsqueda" />
								</td>
								<td align="right" >
									<p:commandLink id="btnDowloadXLS" actionListener="#{rankingPaisesController.exportXLSRankingPaises}" ajax="false" style="margin-right:20px;" title="Descargar PDF" >  
								        <p:graphicImage value="/imagenes/iconos/excel.gif" style="border:0;" ></p:graphicImage>
								    </p:commandLink> 
									<p:commandLink id="btnDowloadPDF" actionListener="#{rankingPaisesController.exportPDFRankingPaises}" ajax="false" style="margin-right:20px;" title="Descargar PDF" >  
								        <p:graphicImage value="/imagenes/iconos/pdf.png" style="border:0;" ></p:graphicImage>
								    </p:commandLink>
								</td>
							</tr>
						</table>
					</f:facet>
	
					<h:panelGrid columns="7" style="margin-top: -15px;margin-left: 6px;">
						<p:spacer width="70" height="15" ></p:spacer>
						<p:spacer width="150" height="15" ></p:spacer>
						<p:spacer width="100" height="15" ></p:spacer>
						<p:spacer width="200" height="15" ></p:spacer>
						<p:spacer width="100" height="15" ></p:spacer>
						<p:spacer width="210" height="15" ></p:spacer>
						<p:spacer width="100" height="15" ></p:spacer>
	
						<h:outputText value="País:" styleClass="texto"></h:outputText>
						<p:autoComplete value="#{comunController.paisSeleccionado}" completeMethod="#{comunController.completarPais}" forceSelection="true"
							var="pais" itemLabel="#{pais.descripcion}" itemValue="#{pais}" converter="paisConverter" dropdown="true" scrollHeight="140">
							<p:ajax event="itemSelect" />
						</p:autoComplete>
	
						<h:outputText value=""></h:outputText>
						<h:outputText value=""></h:outputText>
	
						<h:outputText value="Exclusividad Bancos:" styleClass="texto" ></h:outputText>
						<p:selectOneMenu value="#{comunController.exclusivBancoClaveSeleccionado}" effect="fade" converter="multiTablaConverter">  
							<f:selectItems value="#{comunController.listExclusividadBancoClave}"/>
						</p:selectOneMenu>
	
						<h:outputText value=""></h:outputText>
	
						<h:outputText value="Fecha Desde:" styleClass="texto"></h:outputText>
						<p:calendar locale="es" showButtonPanel="false" showOn="button"  pattern="dd/MM/yyyy" size="10" maxlength="10"
								value="#{rankingPaisesController.busquedaForm.dtFechaIni}"  >
								<p:ajax event="dateSelect" listener="#{rankingPaisesController.validaRangoFechas}" update=":formPrincipal:growl" ></p:ajax>
								<p:ajax event="change" listener="#{rankingPaisesController.validateDateChange}" update=":formPrincipal:growl"/>
						</p:calendar>
	
						<h:outputText value="Fecha Hasta:" styleClass="texto"></h:outputText>
						<p:calendar locale="es" showButtonPanel="false" showOn="button"  pattern="dd/MM/yyyy" size="10" maxlength="10"
								value="#{rankingPaisesController.busquedaForm.dtFechaFin}" >
								<p:ajax event="dateSelect" listener="#{rankingPaisesController.validaRangoFechas}"  update=":formPrincipal:growl" ></p:ajax>
								<p:ajax event="change" listener="#{rankingPaisesController.validateDateChange}" update=":formPrincipal:growl"/>
						</p:calendar>
	
						<h:outputText value="Exclusividad Bancos:" styleClass="texto"></h:outputText>
						<p:selectOneMenu value="#{comunController.exclusivBancoSeleccionado}" effect="fade" converter="multiTablaConverter">  
							<f:selectItems value="#{comunController.listExclusividadBanco}"/>
						</p:selectOneMenu>
	
						<h:outputText value=""></h:outputText>
	
						<h:outputText value="Top Países:" styleClass="texto"></h:outputText>
						<h:inputText styleClass="cajaST" style="width:80%"  value="#{rankingPaisesController.busquedaForm.lngTopPais}" ></h:inputText>
						
						<h:outputText value="Exclusividad Operación:" styleClass="texto"></h:outputText>
						<p:selectOneMenu value="#{comunController.exclusivAladiSeleccionado}" effect="fade" converter="multiTablaConverter">  
				            <f:selectItems value="#{comunController.listExclusividadAladi}"/>
				        </p:selectOneMenu>
						<p:commandButton value="Buscar" id="idBuscarRakingPaises" style="width:99%;" actionListener="#{rankingPaisesController.buscarRankingPaises}" update=":formPrincipal:tabView,:formPrincipal:growl" ></p:commandButton>
					</h:panelGrid>
				</h:panelGrid>
				<h:panelGrid headerClass="cabeceraPanelSimple" cellspacing="0"
					cellpadding="5" styleClass="bordePanel"
					style="width:100%;margin-left: 0px;" columns="1">
	
					<f:facet name="header">
						<h:outputText value="Resultados" />
					</f:facet>
	
					<p:tabView id="tabView" dynamic="true" cache="true" activeIndex="#{rankingPaisesController.idxTabResult}" >
						<p:tab id="tba1" title="Importaciones">
							<p:dataTable var="fila" value="#{rankingPaisesController.listaBPaisResultadoImportaciones}"
								style="width:100%;" paginator="true" rows="5"  >
								<p:columnGroup type="header" >
									<p:row>
										<p:column width="140" rowspan="3" headerText="PAISES" sortBy="#{fila.nomPais}" />
										<p:column rowspan="3" headerText="# Clientes" sortBy="#{fila.nroCliente}" />
										<p:column rowspan="2" colspan="3" headerText="TOTAL MEDIOS DE PAGO" />
										<p:column colspan="11" headerText="IMPORTACIONES" />
									</p:row>
									<p:row>
										<p:column colspan="3" headerText="Transferencias Emitidas" />
										<p:column colspan="3" headerText="Carta de Crédito" />
										<p:column colspan="3" headerText="Cobranzas" />
										<p:column colspan="2" headerText="Financiamiento" />
									</p:row>
									<p:row>
										<p:column headerText="Bcos." sortBy="#{fila.totalBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.totalOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.totalImporte}" />
										<p:column headerText="Bcos." sortBy="#{fila.iTeBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iTeOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iTeImpUSD}" />
										<p:column headerText="Bcos." sortBy="#{fila.iCcBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCcOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCcImpUSD}" />
										<p:column headerText="Bcos" sortBy="#{fila.iCBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCImpUSD}" />
										<p:column headerText="# Oper" sortBy="#{fila.iFOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iFImpUSD}" />
									</p:row>
								</p:columnGroup>
								<p:subTable var="detalleST" value="#{fila.listaClaves}">
									<f:facet name="header"> #{fila.nomPais}</f:facet>
									<p:column >#{detalleST.tipo}</p:column>
									<p:column styleClass="columnNumero">#{detalleST.totCli}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totBcos}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totOper}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">
										<h:outputText value ="#{detalleST.totImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.txBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.txOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.txImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.lcBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.lcOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.lcImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.clBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.clOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.clImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.fiOper}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">
										<h:outputText value ="#{detalleST.fiImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:columnGroup type="footer">
										<p:row>
											<p:column footerText="Total: " style="text-align:right" />
											<p:column footerText="#{fila.nroCliente}" style="text-align:right"  />
											<p:column footerText="#{fila.totalBcos}" style="text-align:right"  />
											<p:column footerText="#{fila.totalOper}" style="text-align:right"  />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.totalImporte}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iTeBcos}" style="text-align:right"  />
											<p:column footerText="#{fila.iTeOper}" style="text-align:right"  />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iTeImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iCcBcos}" style="text-align:right"  />
											<p:column footerText="#{fila.iCcOper}" style="text-align:right"  />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCcImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iCBcos}" style="text-align:right"  />
											<p:column footerText="#{fila.iCOper}" style="text-align:right"  />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iFOper}" style="text-align:right"  />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iFImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
										</p:row>
									</p:columnGroup>
								</p:subTable>
								<p:columnGroup type="footer">
									<p:row>
										<p:column footerText="SubTotal Países con clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="SubTotal Países sin clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="TOTAL" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.totalPaisImp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.totalPaisImp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
								</p:columnGroup>
							</p:dataTable>
						</p:tab>
						<p:tab id="tba2" title="Exportaciones">
							<p:dataTable var="fila" value="#{rankingPaisesController.listaBPaisResultadoExportaciones}"
								style="width:100%;" paginator="true" rows="5" >
								<p:columnGroup type="header">
									<p:row>
										<p:column width="140" rowspan="3" headerText="PAISES" sortBy="#{fila.nomPais}" />
										<p:column rowspan="3" headerText="# Clientes" sortBy="#{fila.nroCliente}" />
										<p:column rowspan="2" colspan="3" headerText="TOTAL MEDIOS DE PAGO" />
										<p:column colspan="11" headerText="EXPORTACIONES" />
									</p:row>
									<p:row>
										<p:column colspan="3" headerText="Transferencias Recibidas" />
										<p:column colspan="3" headerText="Carta de Credito" />
										<p:column colspan="3" headerText="Cobranzas" />
										<p:column colspan="2" headerText="Financiamiento" />
									</p:row>
									<p:row>
										<p:column headerText="Bcos." sortBy="#{fila.totalBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.totalOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.totalImporte}" />
										<p:column headerText="Bcos." sortBy="#{fila.iTeBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iTeOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iTeImpUSD}" />
										<p:column headerText="Bcos." sortBy="#{fila.iCcBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCcOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCcImpUSD}" />
										<p:column headerText="Bcos" sortBy="#{fila.iCBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCImpUSD}" />
										<p:column headerText="# Oper" sortBy="#{fila.iFOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iFImpUSD}" />
									</p:row>
								</p:columnGroup>
								<p:subTable var="detalleST" value="#{fila.listaClaves}">
									<f:facet name="header"> #{fila.nomPais}</f:facet>
									<p:column >#{detalleST.tipo}</p:column>
									<p:column styleClass="columnNumero">#{detalleST.totCli}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totBcos}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totOper}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">
										<h:outputText value ="#{detalleST.totImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.txBcos}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.txOper}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">
										<h:outputText value ="#{detalleST.txImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.lcBcos}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.lcOper}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">
										<h:outputText value ="#{detalleST.lcImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.clBcos}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.clOper}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">
										<h:outputText value ="#{detalleST.clImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.fiOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.fiImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:columnGroup type="footer">
										<p:row>
											<p:column footerText="Total: " style="text-align:right" />
											<p:column footerText="#{fila.nroCliente}" style="text-align:right"/>
											<p:column footerText="#{fila.totalBcos}" style="text-align:right"/>
											<p:column footerText="#{fila.totalOper}" style="text-align:right"/>
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.totalImporte}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iTeBcos}" style="text-align:right"/>
											<p:column footerText="#{fila.iTeOper}" style="text-align:right"/>
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iTeImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iCcBcos}" style="text-align:right"/>
											<p:column footerText="#{fila.iCcOper}" style="text-align:right"/>
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCcImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>	
											<p:column footerText="#{fila.iCBcos}" style="text-align:right"/>
											<p:column footerText="#{fila.iCOper}" style="text-align:right"/>
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iFOper}" style="text-align:right"/>
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iFImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
										</p:row>
									</p:columnGroup>
								</p:subTable>
								<p:columnGroup type="footer">
									<p:row>
										<p:column footerText="SubTotal Países con clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="SubTotal Países sin clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="TOTAL" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.totalPaisExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.totalPaisExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
								</p:columnGroup>
							</p:dataTable>
						</p:tab>
						<p:tab id="tba3" title="Importaciones y Exportaciones">
							<p:dataTable var="fila" value="#{rankingPaisesController.listaBPaisResultadoImpoExpo}"
								style="width:100%;" paginator="true" rows="5" >
								<p:columnGroup type="header">
									<p:row>
										<p:column width="140" rowspan="3" headerText="PAISES" sortBy="#{fila.nomPais}" />
										<p:column rowspan="3" headerText="# Clientes" sortBy="#{fila.nroCliente}" />
										<p:column rowspan="2" colspan="3" headerText="TOTAL MEDIOS DE PAGO" />
										<p:column colspan="11" headerText="IMPORTACIONES + EXPORTACIONES" />
									</p:row>
									<p:row>
										<p:column colspan="3" headerText="Total Transferencias" />
										<p:column colspan="3" headerText="Total Carta de Crédito" />
										<p:column colspan="3" headerText="Total Cobranzas" />
										<p:column colspan="2" headerText="Total Financiamiento" />
									</p:row>
									<p:row>
										<p:column headerText="Bcos." sortBy="#{fila.totalBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.totalOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.totalImporte}" />
										<p:column headerText="Bcos." sortBy="#{fila.iTeBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iTeOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iTeImpUSD}" />
										<p:column headerText="Bcos." sortBy="#{fila.iCcBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCcOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCcImpUSD}" />
										<p:column headerText="Bcos" sortBy="#{fila.iCBcos}" />
										<p:column headerText="# Oper" sortBy="#{fila.iCOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iCImpUSD}" />
										<p:column headerText="# Oper" sortBy="#{fila.iFOper}" />
										<p:column headerText="Importe USD" sortBy="#{fila.iFImpUSD}" />
									</p:row>
								</p:columnGroup>
								<p:subTable var="detalleST" value="#{fila.listaClaves}">
									<f:facet name="header"> #{fila.nomPais}</f:facet>
									<p:column >#{detalleST.tipo}</p:column>
									<p:column styleClass="columnNumero">#{detalleST.totCli}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totBcos}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">#{detalleST.totOper}</p:column>
									<p:column styleClass="columnNumero columnColorMelon">
										<h:outputText value ="#{detalleST.totImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.txBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.txOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.txImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.lcBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.lcOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.lcImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.clBcos}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">#{detalleST.clOper}</p:column>
									<p:column styleClass="columnNumero columnColorCeleste">
										<h:outputText value ="#{detalleST.clImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">#{detalleST.fiOper}</p:column>
									<p:column styleClass="columnNumero columnColorVerdeClaro">
										<h:outputText value ="#{detalleST.fiImporte}">
											<f:convertNumber pattern="#,##0.00" locale="US" />
										</h:outputText>
									</p:column>
									<p:columnGroup type="footer">
										<p:row>
											<p:column footerText="Total: " style="text-align:right" />
											<p:column footerText="#{fila.nroCliente}" style="text-align:right" />
											<p:column footerText="#{fila.totalBcos}" style="text-align:right" />
											<p:column footerText="#{fila.totalOper}" style="text-align:right" />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.totalImporte}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iTeBcos}" style="text-align:right" />
											<p:column footerText="#{fila.iTeOper}" style="text-align:right" />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iTeImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iCcBcos}" style="text-align:right" />
											<p:column footerText="#{fila.iCcOper}" style="text-align:right" />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCcImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iCBcos}" style="text-align:right" />
											<p:column footerText="#{fila.iCOper}" style="text-align:right" />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iCImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
											<p:column footerText="#{fila.iFOper}" style="text-align:right" />
											<p:column style="text-align:right">
												<f:facet name="footer">
													<h:outputText value ="#{fila.iFImpUSD}">
														<f:convertNumber pattern="#,##0.00" locale="US" />
													</h:outputText>
												</f:facet>
											</p:column>
										</p:row>
									</p:columnGroup>
								</p:subTable>
								<p:columnGroup type="footer">
									<p:row>
										<p:column footerText="SubTotal Países con clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImpExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImpExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImpExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisConClaveImpExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisConClaveImpExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="SubTotal Países sin clave" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImpExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.subTotalPaisSinClaveImpExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
									<p:row>
										<p:column footerText="TOTAL" style="text-align:left;height: 28px; font-size: 10px;" />
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.nroCliente}" style="text-align:right"/>
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.totalBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.totalOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImpExp.totalImporte}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iTeBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iTeOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImpExp.iTeImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iCcBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iCcOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImpExp.iCcImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iCBcos}" style="text-align:right"  />
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iCOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImpExp.iCImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
										<p:column footerText="#{rankingPaisesController.totalPaisImpExp.iFOper}" style="text-align:right"  />
										<p:column style="text-align:right">
											<f:facet name="footer">
												<h:outputText value ="#{rankingPaisesController.totalPaisImpExp.iFImpUSD}">
													<f:convertNumber pattern="#,##0.00" locale="US" />
												</h:outputText>
											</f:facet>
										</p:column>
									</p:row>
								</p:columnGroup>
							</p:dataTable>
						</p:tab>
					</p:tabView>
				</h:panelGrid>
			</h:panelGrid>
			<p:blockUI block=":formPrincipal:pnlGripRakingPaises" trigger=":formPrincipal:idBuscarRakingPaises">
				<p:graphicImage value="/imagenes/iconos/busy.gif" style="border:0;"/>Cargando...
			</p:blockUI>
		</ui:define>
	</ui:composition>
</jsp:root>